SELECT Id FROM new_searchtable
where (town like 'Lyme' and state='NH'
or town like 'Enfield' and state='NH'
or town like 'Lebanon' and state='NH'
or town like 'Hanover' and state='NH'
or town like 'Plainfield'and state='NH'
or town like 'Cornish'and state='NH'
or town like 'Grantham'and state='NH'
or town like 'Eastman'and state='NH'
or town like 'Dorchester'and state='NH' )
and list_price > '700000' and type ='L'
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Dartmouth Area Luxury NH Land / Acres page 5
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:An incredible opportunity awaits with these two premium building lots in Hanover, NH, located just minutes from downtown, Dartmouth College's campus, all 3 Hanover public schools, and Dartmouth Health Medical Center. Create a family compound and estate on both parcels, or build your dream home on one lot and sell the other. The possibilities are endless. The land has been thoughtfully cleared to create a canvas for a buyer to imagine the perfect homesite(s). Enjoy the ease of public sewer and water, easy access to all amenities that Hanover and the Upper Valley offer, while also living in a private setting with potential long range views of Ascutney and beyond. Don't miss this unique opportunity to build your perfect residence to call home.
Description:MIXED USE ZONING, UTILITIES AT SITE. Residential 13 UNITS/AC ($5000/du) BEST AND POSSIBLE ONLY feasible RETAIL SITE FOR MARKET AREA. Neighborhood retail underserved. Upper valley and few Industrial sites within 20 miles. Only area business park is sold out. Ongoing demand from Dartmouth start ups. TIF district FOR ON/OFF SITE UPGRADES, quick town approvals. Adjacent add on of 200 acres in Canaan available at $10k/ac. No zoning. 20 minute drive to Medical Center or Campus via I-89 or back country roads. Adjacent is Hanover, with few housing options. Lot prices exceed $300,000. Bargain price for additional 5 minutes drive. Most regional recreation amenities are in Enfield. Ski slope, world class golf course, clean lake Mascoma, 1000 acre open space, rail trail. High ground south sloping with mountain views. Several access points. Road front outparcels available. Adj. town of Lebanon house lots comp at $200k Add on parcel in CAnaan has sand and gravel for developement